At 18:09 +0200 on 26/10/98, Dan Delaney wrote:
> I'd like to set up a DB using postgreSQL to archive a
> mailing list. How would I go about getting all of the mail
> sent to the list to be automatically entered into the
> database when it is sent? I assume I would need to set up an
> email address for the list to send to, something like
> "archive@blahblah.org", but what would I need to do to get
> it into the database? Something in sendmail? Use procmail?
> Any ideas?
Procmail is supposed to be the ultimate solution in this case. Never tried
it myself. However, if you are working with the common unix and sendmail,
you have the possibility of creating a ".forward" file in the "archive"
user's home directory, in which there is one line which reads "|command".
The vertical bar has to be the first character on the line. The command can
be any old script - in this case a script which parses its input (an email
message) and places it in the appropriate tables of your database.
That's how the "vacation" program works. Use "man forward" on your machine
to see how to handle a .forward file.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma